
Use Tunga

GO
--Insert
CREATE PROC insertFoodType
	@[typename] bit
AS
INSERT INTO	FoodType([typename])
VALUES	(@[typename])

GO
--update
CREATE PROC updateFoodType
	@[id] int,
	@[typename] bit
AS
UPDATE FoodType SET	
	[typename] =@[typename]
WHERE 	[id] =@[id]
GO
--Delete
CREATE PROC deleteFoodType
	@[id] int
AS
	DELETE FROM FoodType WHERE [id]=@[id]
GO
--Get All FoodType
CREATE PROC getAllFoodType
AS
SELECT * from FoodType
GO
--get FoodType By ID
CREATE PROC getFoodTypeByID
	@[id] int
AS
SELECT * from FoodType WHERE [id]=@[id]
GO


